Associate Data Engineer (MS SQL)
We are Farmers!
We are... more than just your favorite commercials. At Farmers, we strive to deliver peace of mind to our customers by providing protection and comprehensive advice and delivering in the moments of truth. That means having people who can help us meet changing customer and business needs. Farmers high-performance culture is focused on results and the people who achieve them. We hold ourselves and others accountable for sustainably growing the business and each other. We seek solutions, own our actions, and grow through discomfort. We see setbacks as opportunities while continuously asking ourselves how we impact our customers.
Farmers is an award winning, equal opportunity employer, committed to the strength of a diverse workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isn't just our business - it's our culture! To learn more about our high-performance culture and open opportunities, check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.
Workplace: Hybrid ( #LI-Hybrid ), Remote ( #LI-Remote )
Farmers believes in a culture of collaboration, creativity, and innovation, which thrives when we have the ability to work flexibly in a virtual setting as well as the opportunity to be together in person. Our hybrid work environment combines the best of both worlds with at least three (3) days in office and up to two (2) days virtual for employees who live within fifty (50) miles of a Farmers corporate office. Applicants beyond fifty (50) miles may still be considered.
Job Summary
• Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for simple and basic scenarios.
• Ensures the data is in a ready-to-use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists and data scientists with significant coaching and support.
• Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks.
• Utilizes knowledge of various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools but requires training as needed.
What You'll Do
• Consults on data projects of limited complexity, with coaching and guidance, to understand design requirement and existing business processes to lead in the design, development, and implementation of data products.
• Practices code management and integration with current architectural and data governance guidelines with oversight by leadership.
• Produces data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research & exploration with assistance and coaching.
• Creates business user access methods to structured and unstructured data.
• Utilizes techniques such as mapping data to a common data model, natural language processing, transforming data as necessary to satisfy business rules, AI, statistical computations, and validation of data content.
• Translates business data stories into a technical story breakdown structure and work estimate for a schedule or planned agile sprint.
• Projects are basic in nature and require coaching and assistance from leadership.
• Develops and maintains simple scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support increased demands of data volume and complexity.
• Preps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with significant coaching and feedback.
• Applies basic knowledge of data governance concepts with little to no experience in application.
• Executes on mid size projects within timelines.
• Executes on defined projects with some guidance.
• Performs other duties as assigned.
What You'll Bring
• 1-2 years related experience required.
• 3+ years experience with MS SQL Server, preferred.
• Familiarity with Windows Server environments, preferred.
• Snowflake experience a plus.
Education You'll Need
• High School Diploma or equivalent required.
• Bachelor's degree preferred.
Additional Qualification
• Enthusiastically embrace a wide variety of tasks and responsibilities.
• Possesses strong technical aptitude.
• Basic experience in SQL, Spark (Scala or Python), Spark SQ or equivalent.
• Some experience in dimensional modeling.
• Basic Experience building data pipelines to transform data as per business logic.
• Basic knowledge and understanding with pipeline orchestration.
• Basic experience with BI visualizations such 1 of 2 as Power BI, Tableau etc.
• Some experience interacting with executive and senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization.
• Strong verbal communication and listening skills.
Physical Actions
This role, whether performed virtually or in an office setting, will include normal and customary distractions, noise, and interruptions. Sits or stands for extended periods of time, up to a full work shift. Occasionally reaches overhead and below the knees, including bending, twisting, pulling, and stooping. Occasionally moves, lifts, carries, and places objects and supplies weighing 0-10 pounds without assistance. Listens to, interprets, and differentiates auditory information (example others speaking) at normal speaking levels with or without correction. Visually verifies and reads information. Visually locates material, resources and other objects. Ability to continuously operate a computer for extended periods of time, up to a full work shift. Physical dexterity sufficient to use hands, arms, and shoulders repetitively to operate keyboard and other office equipment up to a full work shift.
Benefits
• Farmers offers a competitive salary commensurate with experience, qualifications and location.
o CA Only: $82,560 - $131,230
o CO Only: $77,360 - $113,520
o HI Only: $77,360 - $121,220
o IL/MN/VT Only: $77,360 - $121,220
• o MD Only: $77,360 - $121,220
o NY/DC/Jersey City Only: $77,360 - $131,230
o Albany County: $82,560 - $113,520
o WA Only: $77,360 - $137,750
• Bonus Opportunity (based on Company and Individual Performance)
• 401(k)
• Medical
• Dental
• Vision
• Health Savings and Flexible Spending Accounts
• Life Insurance
• Paid Time Off
• Paid Parental Leave
• Tuition Assistance
• For more information, review "What we offer" on https://www.farmers.com/careers/corporate/#offer
Job Location(s): R_US - United States
Anticipated application deadline: At Farmers, the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process, we typically close open positions within 8 to 21 days after posting. If you are interested in any of our open positions, we encourage you to submit your application promptly.
Farmers will consider for employment all qualified applicants, including those with criminal histories, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law. Pursuant to 18 U.S.C. Section 1033, Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance.
Want to learn more about our culture & opportunities? Check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.
